--liquibase formatted sql

--changeset hei:insert_houses

--preconditions onFail:WARN
--precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM points
--comment: /* Заполняем таблицу, если она еще пуста */
INSERT INTO points (house, points)
VALUES ('Gryffindor', 0);
--rollback: delete from points where house = 'Gryffindor';
INSERT INTO points (house, points)
VALUES ('Slytherin', 0);
--rollback: delete from points where house = 'Slytherin';
INSERT INTO points (house, points)
VALUES ('Hufflepuff', 0);
--rollback: delete from points where house = 'Hufflepuff';
INSERT INTO points (house, points)
VALUES ('Ravenclaw', 0);
--rollback: delete from points where house = 'Ravenclaw';
